CREATE procedure [dbo].[BAEOrderCheckoutInsert]
    @UserID as varchar(64),
    @Address1 AS varchar(40),
    @Address2 AS varchar(40),
    @Address3 AS varchar(40),
    @City AS varchar(40),
    @State AS varchar(15),
    @PostalCode AS varchar(10),
    @CreditCardType AS varchar(10),
    @CreditCardNumber AS varchar(100),
    @CreditCardExpiration AS varchar(24),
    @CreditCardAuthCode AS varchar(24),
    @CreditCardName AS varchar(40),
    @CreditCardAddress AS varchar(40),
    @CreditCardAddress2 AS varchar(40),
    @CreditCardAddress3 AS varchar(40),
    @CreditCardCity AS varchar(40),
    @CreditCardState AS varchar(15),
    @CreditCardPostalCode AS varchar(10),
    @CreditCardCountry AS varchar(25),
    @ReadyForCheckout AS bit,
    @Country AS varchar(25),
    @ShipMethod AS varchar(10),
    @PurchaseOrder AS varchar(128),
    @Email AS varchar(100),
    @AddressPurpose AS varchar(20),
    @Name AS varchar(70),
    @Issue_Date AS varchar(10),
    @Issue_Number AS varchar(2),
    @MemberType AS varchar(5),
    @BillingCategory AS varchar(60)
AS
    INSERT INTO OrderCheckout
    (    
    UserID,
    Address1,
    Address2,
    Address3,
    City,
    StateProvince,
    PostalCode,
    CreditCardType,
    CreditCardNumber,
    CreditCardExpiration,
    CreditCardAuthCode,
    CreditCardName,
    CreditCardAddress,
    CreditCardAddress2,
    CreditCardAddress3,
    CreditCardCity,
    CreditCardState,
    CreditCardPostalCode,
    CreditCardCountry,
    ReadyForCheckout,
    Country,
    ShipMethod,
    PurchaseOrder,
    Email,
    AddressPurpose,
    ISSUE_DATE,
    ISSUE_NUMBER,
    MemberType,
    BillingCategory,
    [Name]
    )
    VALUES
    (    
    @UserID,
    @Address1,
    @Address2,
    @Address3,
    @City,
    @State,
    @PostalCode,
    @CreditCardType,
    @CreditCardNumber,
    @CreditCardExpiration,
    @CreditCardAuthCode,
    @CreditCardName,
    @CreditCardAddress,
    @CreditCardAddress2,
    @CreditCardAddress3,
    @CreditCardCity,
    @CreditCardState,
    @CreditCardPostalCode,
    @CreditCardCountry,
    @ReadyForCheckout,
    @Country,
    @ShipMethod,
    @PurchaseOrder,
    @Email,
    @AddressPurpose,
    @Issue_Date,
    @Issue_Number,
    @MemberType,
    @BillingCategory,
    @Name                
    );

SELECT CAST(@@IDENTITY AS int) AS 'OrderCheckoutID';

GO